﻿IF EXISTS (SELECT * from sys.procedures p left join sys.schemas s on p.schema_id = s.schema_id where p.name='account_insert' and s.name='Crm')
DROP PROCEDURE [Crm].account_insert
GO
CREATE PROCEDURE [Crm].account_insert 
@PK uniqueidentifier, 
@CategoryID uniqueidentifier, 
@Name nvarchar(200), 
@Address nvarchar(500), 
@ZipCode nvarchar(5), 
@City nvarchar(100), 
@Country nvarchar(100), 
@Url nvarchar(100), 
@Comment nvarchar(4000)
AS
BEGIN
INSERT INTO [Crm].[Accounts]
([id_account], [id_category], [name], [address], [zip_code], [city], [country], [url], [comment])
VALUES (@PK,@CategoryID,@Name,@Address,@ZipCode,@City,@Country,@Url,@Comment)
END